#!/bin/sh

echo
echo Fix test1 ...
echo "UPDATE Games SET TimeControl='5400+30', Site='Plock', EventDate='2015.07.06';" | sqlite3 -echo -batch games.sqlite
echo
echo Fix test2 ...
echo "UPDATE Games SET Board=substr(Round,3),Round=substr(Round,1,1) WHERE Round LIKE '_.%';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Board=substr(Round,4),Round=substr(Round,1,2) WHERE Round LIKE '__.%';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Date='2015.07.06' WHERE Round='1';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Date='2015.07.07' WHERE Round='2';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Date='2015.07.07' WHERE Round='3';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Date='2015.07.08' WHERE Round='4';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Date='2015.07.08' WHERE Round='5';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Date='2015.07.09' WHERE Round='6';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Date='2015.07.09' WHERE Round='7';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Date='2015.07.10' WHERE Round='8';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Date='2015.07.10' WHERE Round='9';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Date='2015.07.11' WHERE Round='10';" | sqlite3 -echo -batch games.sqlite
echo
echo Fix test3 ...
echo "UPDATE Games SET White=substr(White,4) WHERE White LIKE 'O. %';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Black=substr(Black,4) WHERE Black LIKE 'O. %';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET White=substr(White,5) WHERE White LIKE 'K_. %';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Black=substr(Black,5) WHERE Black LIKE 'K_. %';" | sqlite3 -echo -batch games.sqlite

echo "UPDATE Games SET WhiteElo='1522' WHERE White='Domagalski, Fabian';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET WhiteElo=NULL WHERE White='Wiejak, Grzegorz';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET Black='Bak, Stanislaw' WHERE Black='Bak';" | sqlite3 -echo -batch games.sqlite
echo "UPDATE Games SET BlackElo='1542' WHERE Black='Pawlowski, Slawomir';" | sqlite3 -echo -batch games.sqlite
# Transforms lines:
# "  1  II  Ks. Dębowski, Stanisław  POL  1663  1800  Kałków-Godów, D. Radomska  1950"
# into:
# "II|Debowski, Stanislaw|1663|1800|Kalkow-Godow, D. Radomska|1950"
sed -re y/ĄąĆćĘęŁłŃńÓóŚśŹźŻż/AaCcEeLlNnOoSsZzZz/ -e "s/^  [0-9]+  //" -e "s/  POL//" -e "s/K[sl]\. //" -e "s/O\. //" -e "s/  /|/g" lista.txt >lista2.txt
./fixtitle.py lista2.txt games.sqlite
echo Done
